﻿28.4.2013 19:48:15
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 19:48:15
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 19:48:15', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 19:48:15
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 19:48:17
select * from role order by name

28.4.2013 19:48:17
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 19:48:17
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 19:48:17
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 19:48:17
select * from role order by name

28.4.2013 19:48:17
select * from role order by name

28.4.2013 19:48:17
select * from role order by name

28.4.2013 19:48:17
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 19:48:18
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 19:48:18
select * from company order by name

28.4.2013 19:48:20
UPDATE Login SET 
logout = to_date('28.4.2013 19:48:20', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 404 

28.4.2013 19:53:09
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 19:53:09
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 19:53:09', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 19:53:10
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 19:53:14
select * from role order by name

28.4.2013 19:53:14
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 19:53:14
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 19:53:14
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 19:53:14
select * from role order by name

28.4.2013 19:53:18
select * from role order by name

28.4.2013 19:53:18
select * from role order by name

28.4.2013 19:53:18
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 19:53:29
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 19:53:29
select * from company order by name

28.4.2013 19:53:41
select * from company order by name

28.4.2013 19:53:56
select * from Modul 
where userAdd = 8
UNION 
select * from Modul 
where userMod = 8

28.4.2013 19:53:56
select * from [Login]
where idUser = 8

28.4.2013 19:53:56
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 19:53:56
select * from company order by name

28.4.2013 19:53:57
System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at System.Windows.Forms.DataGridViewRowCollection.SharedRow(Int32 rowIndex)
   at System.Windows.Forms.DataGridViewRowCollection.get_Item(Int32 index)
   at ManagerPruzkumnik.Uzivatel.UCUzivatel.FillGrid() in G:\ProjectsSVN\trunk\Pruzkumnik\ManagerPruzkumnik\Uzivatel\UCUzivatel.cs:line 56

28.4.2013 19:54:04
select * from role order by name

28.4.2013 19:54:18
INSERT INTO [User] ( nameLogin, 
password, 
idRole) VALUES (  'Juraj', 
 'test', 
 2) ; SELECT @@Identity

28.4.2013 19:54:18
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 19:54:18
select * from company order by name

28.4.2013 19:54:19
select * from company order by name

28.4.2013 19:54:42
UPDATE [User] SET 
IdCompany = 4, 
 Notes = '', 
 Phone = '', 
 Email = '', 
 Address = '', 
 NameLogin = 'Franta', 
 Password = 'test', 
 Name = 'Juraj', 
 Surname = 'Kernel'
 WHERE idUser = 9 

28.4.2013 19:54:42
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 19:54:42
select * from company order by name

28.4.2013 19:54:42
select * from company order by name

28.4.2013 19:54:51
select * from role order by name

28.4.2013 19:54:51
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 19:54:58
UPDATE [User] SET 
idRole = 5
 WHERE idUser = 9 

28.4.2013 19:54:58
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 19:55:10
select * from role order by name

28.4.2013 19:55:17
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 19:55:17
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 19:55:17
--DECLARE 5 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 5 
order by modul.nameModul

28.4.2013 19:55:50
UPDATE Rights SET 
visible = 0, 
 adding = 0, 
 edit = 1, 
 remove = 1, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

28.4.2013 19:56:45
UPDATE Rights SET 
visible = 1, 
 adding = 0, 
 edit = 1, 
 remove = 1, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

28.4.2013 19:57:12
UPDATE Rights SET 
visible = 1, 
 adding = 1, 
 edit = 1, 
 remove = 1, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

28.4.2013 19:58:32
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 19:58:37
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 19:58:46
UPDATE Login SET 
logout = to_date('28.4.2013 19:58:46', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 407 

28.4.2013 20:06:50
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 20:06:50
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 20:06:50', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 20:06:50
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 20:07:09
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  'Testovací modul 7', 
 '', 
 '100', 
 '', 
 NULL, 
 NULL, 
 1, 
 to_date('28.4.2013 20:07:09', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

28.4.2013 20:07:09
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 20:07:19
UPDATE Modul SET 
nameModul = 'Testovací modul 7', 
 idParent = '0', 
 orderModul = '70', 
 sqlQuery = '', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 20:07:19', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 35 

28.4.2013 20:07:19
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 20:07:42
UPDATE Modul SET 
nameModul = 'Testovací modul 7', 
 idParent = '0', 
 orderModul = '70', 
 sqlQuery = 'select * from dotaznik', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 20:07:42', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 35 

28.4.2013 20:07:42
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 20:07:47
select * from dotaznik

28.4.2013 20:07:50
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 20:09:26
UPDATE Login SET 
logout = to_date('28.4.2013 20:09:26', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 409 

28.4.2013 20:46:11
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 20:46:11
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 20:46:11', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 20:46:11
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 20:46:15
select * from role order by name

28.4.2013 20:46:15
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 20:46:15
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 20:46:15
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 20:46:15
select * from role order by name

28.4.2013 20:46:16
select * from role order by name

28.4.2013 20:46:16
select * from role order by name

28.4.2013 20:46:16
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 20:46:17
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 20:46:17
select * from company order by name

28.4.2013 20:46:19
UPDATE Login SET 
logout = to_date('28.4.2013 20:46:19', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 329 

28.4.2013 20:57:41
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 20:57:41
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 20:57:41', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 20:57:41
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 20:57:56
UPDATE Login SET 
logout = to_date('28.4.2013 20:57:56', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 331 

28.4.2013 21:00:54
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 21:00:54
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 21:00:54', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 21:00:54
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:01:21
select top 10 * from dotaznik

28.4.2013 21:01:23
UPDATE Modul SET 
nameModul = 'Testovaci modul 1', 
 idParent = '0', 
 orderModul = '10', 
 sqlQuery = 'select top 10 * from dotaznik', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:01:23', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 1 

28.4.2013 21:01:23
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:02:06
UPDATE Modul SET 
nameModul = 'Testovací modul 1.2.1', 
 idParent = '16', 
 orderModul = '10', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = 'nazev=Testovací_modul_1.2.1', 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:02:06', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 19 

28.4.2013 21:02:07
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:03:03
UPDATE Modul SET 
nameModul = 'Testovací modul 1.2.1', 
 idParent = '16', 
 orderModul = '10', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovací_modul_1.2.1', 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:03:03', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 19 

28.4.2013 21:03:04
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:03:36
UPDATE Modul SET 
nameModul = 'Testovací modul 1.2.2', 
 idParent = '16', 
 orderModul = '20', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovací_modul_1.2.2', 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:03:36', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 20 

28.4.2013 21:03:36
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:03:58
select top 3 * from dotaznik

28.4.2013 21:04:02
UPDATE Modul SET 
nameModul = 'Testovací modul 1.3', 
 idParent = '1', 
 orderModul = '30', 
 sqlQuery = 'select top 3 * from dotaznik', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:04:02', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 17 

28.4.2013 21:04:02
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:04:21
UPDATE Modul SET 
nameModul = 'Testovací modul 1.4', 
 idParent = '1', 
 orderModul = '40', 
 sqlQuery = 'select top 15 * from dotaznik', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:04:21', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 18 

28.4.2013 21:04:21
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:08:04
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:08:24
UPDATE Modul SET 
nameModul = 'Testovaci subsubmodul 2.1.1', 
 idParent = '5', 
 orderModul = '0', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovací_modul_2.1.1', 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:08:24', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 10 

28.4.2013 21:08:24
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:09:03
UPDATE Modul SET 
nameModul = 'Testovaci submodul 2.2', 
 idParent = '2', 
 orderModul = '0', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovací_modul_2.2', 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:09:03', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 7 

28.4.2013 21:09:03
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:09:20
UPDATE Modul SET 
nameModul = 'Testovaci modul 4', 
 idParent = '0', 
 orderModul = '40', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovací_modul_4', 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:09:20', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 9 

28.4.2013 21:09:20
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:09:46
UPDATE Modul SET 
nameModul = 'Testovaci modul 5', 
 idParent = '0', 
 orderModul = '50', 
 sqlQuery = 'select * from TestTable', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:09:46', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 8 

28.4.2013 21:09:46
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:10:06
UPDATE Modul SET 
nameModul = 'Testovaci modul 7', 
 idParent = '0', 
 orderModul = '70', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovací_modul_7', 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:10:06', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 13 

28.4.2013 21:10:06
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:10:24
UPDATE Modul SET 
nameModul = 'Testovaci modul 5.1', 
 idParent = '8', 
 orderModul = '0', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovací_modul_5.1', 
 userMod = 1, 
 dateMod = to_date('28.4.2013 21:10:24', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 11 

28.4.2013 21:10:24
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:13:11
UPDATE Login SET 
logout = to_date('28.4.2013 21:13:11', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 326 

28.4.2013 21:44:41
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 21:44:41
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 21:44:41', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 21:44:41
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 21:46:21
UPDATE Login SET 
logout = to_date('28.4.2013 21:46:21', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 332 

28.4.2013 22:10:23
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 22:10:23
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 22:10:23', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 22:10:24
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:10:29
select * from role order by name

28.4.2013 22:10:29
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:10:29
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:10:29
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 22:10:29
select * from role order by name

28.4.2013 22:10:34
select * from role order by name

28.4.2013 22:10:34
select * from role order by name

28.4.2013 22:10:34
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 22:10:41
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 22:10:41
select * from company order by name

28.4.2013 22:17:09
UPDATE Login SET 
logout = to_date('28.4.2013 22:17:09', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 337 

28.4.2013 22:21:59
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 22:21:59
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 22:21:59', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 22:21:59
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:22:02
select * from role order by name

28.4.2013 22:22:02
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:22:02
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:22:02
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 22:22:02
select * from role order by name

28.4.2013 22:22:04
UPDATE Login SET 
logout = to_date('28.4.2013 22:22:04', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 339 

28.4.2013 22:24:17
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 22:24:17
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 22:24:17', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 22:24:17
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:24:20
select * from role order by name

28.4.2013 22:24:20
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:24:20
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:24:20
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 22:24:20
select * from role order by name

28.4.2013 22:24:24
select * from role order by name

28.4.2013 22:24:24
select * from role order by name

28.4.2013 22:24:24
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 22:24:33
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 22:24:33
select * from company order by name

28.4.2013 22:24:39
select * from role order by name

28.4.2013 22:24:50
INSERT INTO [User] ( nameLogin, 
password, 
idRole) VALUES (  'Juraj', 
 'test', 
 3) ; SELECT @@Identity

28.4.2013 22:24:50
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 22:24:50
select * from company order by name

28.4.2013 22:24:52
select * from company order by name

28.4.2013 22:25:12
UPDATE [User] SET 
IdCompany = NULL, 
 Notes = '', 
 Phone = '', 
 Email = '', 
 Address = '', 
 NameLogin = 'Juro', 
 Password = 'test', 
 Name = 'Juraj', 
 Surname = 'Kupec'
 WHERE idUser = 8 

28.4.2013 22:25:12
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 22:25:12
select * from company order by name

28.4.2013 22:25:12
select * from company order by name

28.4.2013 22:25:27
select * from company order by name

28.4.2013 22:25:41
select * from Modul 
where userAdd = 5
UNION 
select * from Modul 
where userMod = 5

28.4.2013 22:25:42
select * from [Login]
where idUser = 5

28.4.2013 22:25:42
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 22:25:42
select * from company order by name

28.4.2013 22:25:42
System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.ArrayList.get_Item(Int32 index)
   at System.Windows.Forms.DataGridViewRowCollection.SharedRow(Int32 rowIndex)
   at System.Windows.Forms.DataGridViewRowCollection.get_Item(Int32 index)
   at ManagerPruzkumnik.Uzivatel.UCUzivatel.FillGrid() in G:\ProjectsSVN\trunk\Pruzkumnik\ManagerPruzkumnik\Uzivatel\UCUzivatel.cs:line 56

28.4.2013 22:25:44
select * from company order by name

28.4.2013 22:25:47
select * from role order by name

28.4.2013 22:25:47
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 22:25:55
UPDATE [User] SET 
idRole = 5
 WHERE idUser = 8 

28.4.2013 22:25:55
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 22:25:59
select * from role order by name

28.4.2013 22:26:30
UPDATE Rights SET 
visible = 0, 
 adding = 1, 
 edit = 1, 
 remove = 1, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

28.4.2013 22:26:58
UPDATE Rights SET 
visible = 1, 
 adding = 0, 
 edit = 1, 
 remove = 0, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

28.4.2013 22:27:27
select * from role order by name

28.4.2013 22:27:30
UPDATE Rights SET 
visible = 1, 
 adding = 1, 
 edit = 1, 
 remove = 1, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

28.4.2013 22:28:01
select top 3 * from dotaznik

28.4.2013 22:28:05
UPDATE Modul SET 
nameModul = 'Testovaci modul 1', 
 idParent = '0', 
 orderModul = '10', 
 sqlQuery = 'select top 3 * from dotaznik', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 22:28:05', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 1 

28.4.2013 22:28:05
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:28:55
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  'Test modul 8', 
 '0', 
 '200', 
 '', 
 NULL, 
 NULL, 
 1, 
 to_date('28.4.2013 22:28:55', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

28.4.2013 22:28:55
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:29:24
UPDATE Modul SET 
nameModul = 'Test modul 8', 
 idParent = '0', 
 orderModul = '200', 
 sqlQuery = 'select * from dotaznik', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 22:29:24', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 26 

28.4.2013 22:29:24
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:29:45
select * from Rights where idModul = 26

28.4.2013 22:29:45
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:29:48
UPDATE Login SET 
logout = to_date('28.4.2013 22:29:48', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 341 

28.4.2013 22:46:01
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 22:46:01
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 22:46:01', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 22:46:01
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:46:28
select * from dotaznik

28.4.2013 22:46:31
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  'Test modul 8', 
 '', 
 NULL, 
 'select * from dotaznik', 
 NULL, 
 NULL, 
 1, 
 to_date('28.4.2013 22:46:31', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

28.4.2013 22:46:31
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:46:52
UPDATE Modul SET 
nameModul = 'Test modul 8', 
 idParent = '0', 
 orderModul = '200', 
 sqlQuery = 'select * from dotaznik', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 22:46:52', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 27 

28.4.2013 22:46:52
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:47:15
select * from role order by name

28.4.2013 22:47:16
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:47:16
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:47:16
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 22:47:16
select * from role order by name

28.4.2013 22:47:18
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:47:18
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:47:18
--DECLARE 2 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 2 
order by modul.nameModul

28.4.2013 22:47:18
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:47:18
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:47:18
--DECLARE 3 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 3 
order by modul.nameModul

28.4.2013 22:47:19
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:47:19
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:47:19
--DECLARE 5 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 5 
order by modul.nameModul

28.4.2013 22:47:33
UPDATE Login SET 
logout = to_date('28.4.2013 22:47:33', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 344 

28.4.2013 22:49:11
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 22:49:11
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 22:49:11', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 22:49:11
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:49:19
select * from Rights where idModul = 27

28.4.2013 22:49:19
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:49:50
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:49:50
System.NullReferenceException: Object reference not set to an instance of an object.
   at ManagerPruzkumnik.Moduly.UCEditaceModulu.FillPanelModulInfo(Modul modul) in G:\ProjectsSVN\trunk\Pruzkumnik\ManagerPruzkumnik\Editace modulu\UCEditaceModulu.cs:line 245

28.4.2013 22:49:56
select top 3 * from dotaznik

28.4.2013 22:49:59
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 22:50:02
select * from role order by name

28.4.2013 22:50:02
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:50:02
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:50:02
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 22:50:02
select * from role order by name

28.4.2013 22:50:03
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:50:03
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:50:03
--DECLARE 2 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 2 
order by modul.nameModul

28.4.2013 22:50:04
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:50:04
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 22:50:04
--DECLARE 3 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 3 
order by modul.nameModul

28.4.2013 22:50:18
UPDATE Rights SET 
visible = 0, 
 adding = 1, 
 edit = 1, 
 remove = 1, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

28.4.2013 22:50:30
UPDATE Rights SET 
visible = 1, 
 adding = 1, 
 edit = 1, 
 remove = 1, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

28.4.2013 22:50:39
select * from role order by name

28.4.2013 22:50:39
select * from role order by name

28.4.2013 22:50:39
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 22:50:48
UPDATE [User] SET 
idRole = 3
 WHERE idUser = 8 

28.4.2013 22:50:48
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 22:50:50
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 22:50:50
select * from company order by name

28.4.2013 22:50:55
select * from role order by name

28.4.2013 22:51:07
INSERT INTO [User] ( nameLogin, 
password, 
idRole) VALUES (  'Franta', 
 'test', 
 2) ; SELECT @@Identity

28.4.2013 22:51:07
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 22:51:07
select * from company order by name

28.4.2013 22:51:08
select * from company order by name

28.4.2013 22:51:26
UPDATE [User] SET 
IdCompany = 2, 
 Notes = '', 
 Phone = '', 
 Email = '', 
 Address = '', 
 NameLogin = 'Franta', 
 Password = 'test', 
 Name = 'Frantisek', 
 Surname = 'Kubalovič'
 WHERE idUser = 9 

28.4.2013 22:51:26
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 22:51:26
select * from company order by name

28.4.2013 22:51:26
select * from company order by name

28.4.2013 22:51:30
select * from company order by name

28.4.2013 22:51:31
select * from company order by name

28.4.2013 22:51:32
select * from role order by name

28.4.2013 22:51:32
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 22:51:38
UPDATE Login SET 
logout = to_date('28.4.2013 22:51:38', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 346 

29.4.2013 19:42:00
select * from [User] where nameLogin = @nameLogin and password = @password

29.4.2013 19:42:00
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('29.4.2013 19:42:00', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

29.4.2013 19:42:00
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

29.4.2013 19:42:03
select * from role order by name

29.4.2013 19:42:03
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

29.4.2013 19:42:03
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

29.4.2013 19:42:03
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

29.4.2013 19:42:03
select * from role order by name

29.4.2013 19:42:04
select * from role order by name

29.4.2013 19:42:04
select * from role order by name

29.4.2013 19:42:04
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

29.4.2013 19:42:05
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

29.4.2013 19:42:05
select * from company order by name

29.4.2013 19:42:07
UPDATE Login SET 
logout = to_date('29.4.2013 19:42:07', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 350 

